
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

IF EXISTS (select * from sys.objects where type = 'p' and name = 'GetPresetByType' ) 
	DROP PROCEDURE GetMemberById
GO

CREATE PROCEDURE GetPresetByType
(
	@PRSET_TYPE int
)
AS

BEGIN
	SET NOCOUNT ON;
	select * 
	from dbo.PRESET
	where PRSET_TYPE = @PRSET_TYPE
END

GO
